package com.gzhuxj201.mapper;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface TCMapper {
    @Select("select cno from tc where tno=#{tno}")
    List<String> selectByTno(String tno);

    @Delete("delete from tc where cno=#{cno}")
    int deleteByCno(String cno);

    @Insert("insert into tc values(#{tno},#{cno})")
    int add(String tno, String cno);
}
